To choose a security model
- Select File> System Setup to open the System Setup window.
- Click SQL Security Setup to open the SQL Security Setup window.
- Select the appropriate security model:
- Model 1 - Passthrough
- Model 2 - Parallel login ID's (requires entering a password in the Master Password and Verify Password fields)
- Model 3 - Unilogin (requires entering a password in the Master Password and Verify Password fields)
- (Optional) Enter the NOLOCK Keyword. Normally, when a large report is running, the system puts locks on the data that prevents others from modifying this same data. This is done for data consistency and to avoid generating old and inaccurate information. The NOLOCK Keyword option prevents locking data and allows data entry while a report is running. If you enter a NOLOCK Keyword, the report may not reflect the latest state of the data. There are two options that need to be set:
- In the NOLOCK Keyword field, enter noholdlock in upper- or lowercase for Sybase, or enter nolock in upper- or lowercase for SQL Server.
- Select Utilities> Report Specs. Select the report, click Edit, and click Parameters. Enter NOLOCK in uppercase in the Parameters field.
- Click Save.
- On the System Setup window, click User Passwords to open the User Passwords window.
- Click Update All SQL Logins.
- Exit, and restart iMIS.